﻿CREATE TABLE [dbo].[SbDqyh_Info] (
    [jsdbh]  VARCHAR (18) NOT NULL,
    [sfzh]   VARCHAR (18) NOT NULL,
    [sblsh]  INT          NOT NULL,
    [kh]     VARCHAR (10) NULL,
    [ryid]   INT          NULL,
    [sfhbmd] BIT          NULL,
    [sfkqfq] BIT          NULL,
    [yxjcsj] DATETIME     NULL,
    CONSTRAINT [PK_SBDQYH_INFO] PRIMARY KEY CLUSTERED ([jsdbh] ASC, [sfzh] ASC, [sblsh] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否开启反潜', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SbDqyh_Info', @level2type = N'COLUMN', @level2name = N'sfkqfq';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否黑白名单（西可需要，西可权限分为能进权限，在能进里再分黑白名单）', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SbDqyh_Info', @level2type = N'COLUMN', @level2name = N'sfhbmd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'如果是单机版为卡号如果是联机版为身份证号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SbDqyh_Info', @level2type = N'COLUMN', @level2name = N'sfzh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'监视点编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SbDqyh_Info', @level2type = N'COLUMN', @level2name = N'jsdbh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'监视点人员权限变更信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SbDqyh_Info';

